/*
* This software is licensed under the GNU General Public License, version 2
* You may copy, distribute and modify the software as long as you track changes/dates of in source files and keep all modifications under GPL. You can distribute your application using a GPL library commercially, but you must also provide the source code.

* DNNspot Software (http://www.dnnspot.com)
* Copyright (C) 2013 Atriage Software LLC
* Authors: Kevin Southworth, Matthew Hall, Ryan Doom

* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU General Public License
* as published by the Free Software Foundation; either version 2
* of the License, or (at your option) any later version.

* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU General Public License for more details.

* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

* Full license viewable here: http://www.gnu.org/licenses/gpl-2.0.txt
*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DNNspot.LiveChat.DataModel
{
    public partial class Session
    {
        public static Session Create(int portalId, int categoryId, int clientId, string urlReferrer, string question, string notes)
        {
            var session = new Session();
            session.PortalId = portalId;
            session.CategoryId = categoryId;
            session.ClientId = clientId;
            session.Question = question;
            session.UrlReferrer = urlReferrer;
            session.Notes = notes;

            session.Save();

            return session;
        }

        public static Session Load(int? sessionId)
        {
            var session = new Session();

            if (sessionId != null)
                session.LoadByPrimaryKey(Convert.ToInt32(sessionId));

            return session;
        }
    }

    public partial class SessionCollection
    {
        public static int GetTotal(FlexigridSearchCriteria searchCriteria)
        {
            var tmpNumber = searchCriteria.PageNumber;
            var tmpSize = searchCriteria.PageSize;

            searchCriteria.PageNumber = -1;
            searchCriteria.PageSize = -1;

            var count = Search(searchCriteria).Count;

            searchCriteria.PageNumber = tmpNumber;
            searchCriteria.PageSize = tmpSize;

            return count;
        }

        public static List<Session> Search(FlexigridSearchCriteria searchCriteria)
        {
            var q = new SessionQuery();

            if (searchCriteria.PageNumber > 0 && searchCriteria.PageSize > 0)
            {
                q.es.PageNumber = searchCriteria.PageNumber;
                q.es.PageSize = searchCriteria.PageSize;
            }

            q.Where(q.PortalId == searchCriteria.PortalId);

            foreach (String keyword in searchCriteria.Query.Split(' '))
            {
                q.And(string.Format("{0} LIKE '%{1}%'", searchCriteria.QueryColumns, keyword));
            }

            q.OrderBy(searchCriteria.SortColumn, searchCriteria.SortDirection);

            var sessions = new SessionCollection();
            sessions.Load(q);

            return sessions.ToList();
        }
    }
}
